UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJBlEJ8p8iZuuvs7VKDiovjmff+M6KV+zwa9GQvmZK4='
WHERE
key_id = '89914c453b8f39303daaa0859565726a4130e6459b398845c65116168d50fc47'
AND (
token = 'qJBlEJ8p8iZuuvs7VKDiovjmff+M6KV+zwa9GQvmZK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)