UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZOSZrET0SsfiMYWZ++Myj8vP35ooVEthohfs80Sar+U='
WHERE
key_id = '85f37421e83a05619894d23959a11d208a278ad760ec45dc7a532ab48c4214a6'
AND (
token = 'ZOSZrET0SsfiMYWZ++Myj8vP35ooVEthohfs80Sar+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)