UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKn7VzfyZX6y/BW5rCkfJqFHly7330ZHMEcr6o3Wmxc='
WHERE
key_id = '475aec73892a2accdb4190ddefef8434ef2dd6fe4f61f9f68a41ee6cad547562'
AND (
token = 'nKn7VzfyZX6y/BW5rCkfJqFHly7330ZHMEcr6o3Wmxc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)