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