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