UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WCy058YkWe49W6yrCcBPggcJ3SEyYS6uJ2mXP/wddDY='
WHERE
key_id = 'c9798ee1871994875935dd9811696dba8b0fce39ede1db12f902d9ac0dfa9571'
AND (
token = 'WCy058YkWe49W6yrCcBPggcJ3SEyYS6uJ2mXP/wddDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)