UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qZ9n/BCRcrE0nJqNxnvhQSJN5LEI4GVxMTW7QHSTQnA='
WHERE
key_id = '304bf16937fc39eacf8c60cecf19467343bb95cdeffc5b37a8434cec6c31f79f'
AND (
token = 'qZ9n/BCRcrE0nJqNxnvhQSJN5LEI4GVxMTW7QHSTQnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)