UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1X5J0Zh94BdTGmII0zeEpBIHVRoMBd+f6hDh2Cm0/S4='
WHERE
key_id = '92d0fe7805f41a39de29ce52afd577ba9ba75815cc82dae7c4fc1d9504c7ba2c'
AND (
token = '1X5J0Zh94BdTGmII0zeEpBIHVRoMBd+f6hDh2Cm0/S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)