UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gGaVgNzQdOfQv9lrqehZVVQoVB/3jJD+6lEnO1oU+nE='
WHERE
key_id = 'afc7e86209207727654304b020d6e1698fe90226ddf5237c9467930b5855b705'
AND (
token = 'gGaVgNzQdOfQv9lrqehZVVQoVB/3jJD+6lEnO1oU+nE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)