UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCptZZgDtYTiq1WZbKV7PeOatlti11YjRoXOFt9Pyb0='
WHERE
key_id = '144f9443d3e7adc07a6a092867b9bfb3cc444a3d121e6f605af6d525273e1a80'
AND (
token = 'TCptZZgDtYTiq1WZbKV7PeOatlti11YjRoXOFt9Pyb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)