UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZifzvR6PrQAvxyI9fhswKqbGcwbyjEDHzbyBcSdfecI='
WHERE
key_id = '9f801e608e5c90b7d8fd2c567670cc5c2707897876299a3cb62706419623ecc0'
AND (
token = 'ZifzvR6PrQAvxyI9fhswKqbGcwbyjEDHzbyBcSdfecI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)