UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zYmNlVlQslgG5tKyjLDXess5XUS73oWmczA9i7GCNmY='
WHERE
key_id = '1e1d74af7c9f99c93e769d95d3368e22dc5d9a666ee3d156041226e558a968af'
AND (
token = 'zYmNlVlQslgG5tKyjLDXess5XUS73oWmczA9i7GCNmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)