UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OsX662igtseHWMS5JNCho9gfr6tTrjrOJuZOLioODKY='
WHERE
key_id = 'b4593e7dc8d6a7785f78654d65e2ff580569debef59e6d7029fc9c18d83f9f9e'
AND (
token = 'OsX662igtseHWMS5JNCho9gfr6tTrjrOJuZOLioODKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)