UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bi7lodVrF5bTxCffGRRWUrP/I2vR1YLYBo73GhS38nY='
WHERE
key_id = 'f5a10e3ef8f483f9d2c755840985ad5457a245f83f4a3c6710dc42e4a4b83d91'
AND (
token = 'Bi7lodVrF5bTxCffGRRWUrP/I2vR1YLYBo73GhS38nY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)