UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NIZL6dvXOPpD1pYYBrGCs9yxeVve24ULyS57kItq380='
WHERE
key_id = '1fa15e6dc4733192d84035d20779ddf2cec1a20f8bb80ecd2c194e7d68af4cec'
AND (
token = 'NIZL6dvXOPpD1pYYBrGCs9yxeVve24ULyS57kItq380='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)