UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Re4QHn76b2ctbZ3uWM2yjTGa2tVtrIvcD4O07KlMd1E='
WHERE
key_id = '847ea0be301124849c88056042c5bfd4604d1ab41d3cc708327c980ee54a0483'
AND (
token = 'Re4QHn76b2ctbZ3uWM2yjTGa2tVtrIvcD4O07KlMd1E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)