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