UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lEMU+roRuWqbA7n+4oWupHbYh7WbLrBLQYy3tfHPu94='
WHERE
key_id = '5f697eeec3272fbbf96a8ce4fe4d52b24c35c1501f98416ab6e3980c4ff8c87a'
AND (
token = 'lEMU+roRuWqbA7n+4oWupHbYh7WbLrBLQYy3tfHPu94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)