UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Do52I6H8qM8yOO2EGRHfSfRSAXLxB7DF1S6OXi4Kn4='
WHERE
key_id = 'f9ed873bf5949bb71c9e5424043c4450cd5a9a03609ef1c914a9971ecdc60d0b'
AND (
token = '0Do52I6H8qM8yOO2EGRHfSfRSAXLxB7DF1S6OXi4Kn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)