UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Pm8utec+J0jgwCVR0gJAJSkghkL70MhqHNf+HwnHag='
WHERE
key_id = '46aec531ac3f51d74ce18af394ef059177d2bdb7e9130f4dd143e461f96929c7'
AND (
token = '6Pm8utec+J0jgwCVR0gJAJSkghkL70MhqHNf+HwnHag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)