UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9jV+3lIx/ihvSR/QuOnf+L7HF4jx1PHKFicVAqD9+E='
WHERE
key_id = 'b457575a1c1267b4fe01903f94d7a88e806cc14957298c410a55645737519adc'
AND (
token = 'R9jV+3lIx/ihvSR/QuOnf+L7HF4jx1PHKFicVAqD9+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)