UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qcdqN91ozzRlyctHoBOYunC6GV6mYABcIYMxjPMbyuM='
WHERE
key_id = '4dec3bb5715691437695737037c0e794675c89b67ca59b3a92f3a579554ff380'
AND (
token = 'qcdqN91ozzRlyctHoBOYunC6GV6mYABcIYMxjPMbyuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)