UPDATE 
  cscart_june_setuplock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zk4yRz2m+xF/3SvGI41ahenKNYzNsxggPTn67Lyh8zo=' 
WHERE 
  key_id = '3ce4edd493e3f3f7edf13fc23e20c86057e387d2ed4c4dc84281597eebad179e' 
  AND (
    token = 'zk4yRz2m+xF/3SvGI41ahenKNYzNsxggPTn67Lyh8zo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033