UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TQBONrt5h2acQt5rLvXms2JrpBNqPB7QxbQis2IUyqc='
WHERE
key_id = '5da4c21cb2923d718ee41e821cb132e1f0374a3e0edf2bbe7e89faa4c0f8c3e6'
AND (
token = 'TQBONrt5h2acQt5rLvXms2JrpBNqPB7QxbQis2IUyqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)