UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3nx933zQkZ+V4IkPWaV3Pp3PD2Yx7YCifNE0wXT9h8='
WHERE
key_id = 'a649e0b3e0661ba0f89a95a60a0f5908bc0149ba41dee38070ee7544a35c5b30'
AND (
token = 'X3nx933zQkZ+V4IkPWaV3Pp3PD2Yx7YCifNE0wXT9h8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)