UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DUMrO5QO7FN1pN2QkfRQWFzGWGeitiIVrrwfypy0ABQ=' 
WHERE 
  key_id = '2e30e2963be280811a2aa4a19e89bcf1b3326a6f18179a34882e33de517ec37e' 
  AND (
    token = 'DUMrO5QO7FN1pN2QkfRQWFzGWGeitiIVrrwfypy0ABQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029