UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9R7gazj7OWjsMQXQudPJpI9I3rGYsA5OxTc4gwAP/U='
WHERE
key_id = 'e902fec74fd07da59ec9d724981e38e059a3974c25cba3ea0fe1354dd440e92b'
AND (
token = 'J9R7gazj7OWjsMQXQudPJpI9I3rGYsA5OxTc4gwAP/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)