UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '89XTzBZn7rvt/DvKe3lGFyZfjD7I+DC1gzN4h2H4qxI='
WHERE
key_id = 'be65bd43cab27f6a14329b04a25d95f4e711e2097df833a2ff4da19e9fb84df5'
AND (
token = '89XTzBZn7rvt/DvKe3lGFyZfjD7I+DC1gzN4h2H4qxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)