UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GBQB7Ip1klx4eou4NcuiofNYrgonLPPct6Vb7RdKTH8='
WHERE
key_id = '790fc1a667914f94591a7b7387c5c1cb970488d243fb2fa756d39cd1b8aa9a50'
AND (
token = 'GBQB7Ip1klx4eou4NcuiofNYrgonLPPct6Vb7RdKTH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)