UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6EsNOi33ZMa0XKETLYz5SMFcMeLOCtzkZXiAk5W1f5A='
WHERE
key_id = '04c698abc01c665e1d138be9278e41c397119f5057b2847c38d15e36d95f3207'
AND (
token = '6EsNOi33ZMa0XKETLYz5SMFcMeLOCtzkZXiAk5W1f5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)