UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xcc8/xzBp4rozzwo3fIrp9JHb7tdA/f2I2Tob1fmTNA='
WHERE
key_id = '1c698e13e5abba5d775541998dcbcf2d5a329e5fc9952968a5395212742316f8'
AND (
token = 'Xcc8/xzBp4rozzwo3fIrp9JHb7tdA/f2I2Tob1fmTNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)