UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KFqWaYqRU2cG4bnOn0ccs5ajV0DcvjhAualFVSCcGU='
WHERE
key_id = 'a8d02b4f7a76027cfaebaa0296d8f59b3aca2fe73ee8417c4cb028ad91a59c23'
AND (
token = '0KFqWaYqRU2cG4bnOn0ccs5ajV0DcvjhAualFVSCcGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)