UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GpIWGYPzED7vfGJx33QZv9iaPv5O0MwoguZ+5Cz49IQ='
WHERE
key_id = '8d9ecd2436d44bc18acec049b1fb2042dc1a47453336c8fb4ed9944f4db07fec'
AND (
token = 'GpIWGYPzED7vfGJx33QZv9iaPv5O0MwoguZ+5Cz49IQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)