UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gE+XdSf2w52+0tKIdh4KhUd7yGjaJCFWeTVoqydiOXs='
WHERE
key_id = 'd1bca6e110c4ed55b8f235f44379e7ffab8188ccbd271be6e419165427c144e9'
AND (
token = 'gE+XdSf2w52+0tKIdh4KhUd7yGjaJCFWeTVoqydiOXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)