UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qXLLJTixhoWAfGivWzZEPpe6AX2Chyc6XAh4aDI2J9U='
WHERE
key_id = '18859de5d56f6235b778cac08e47c21ef6397caec1cb52b1ca2e646e496541f1'
AND (
token = 'qXLLJTixhoWAfGivWzZEPpe6AX2Chyc6XAh4aDI2J9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)