UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TkTgh3hI885Iu8IZozhM5k5NisLLG6Giqj2ONIr5Ys='
WHERE
key_id = '6c3b87c09cbc8bb9e1e8bfb4b5e3c72676b65d87867b519e2efa726db4aab39a'
AND (
token = '6TkTgh3hI885Iu8IZozhM5k5NisLLG6Giqj2ONIr5Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)