UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0eOaI+CZo3/zxXhSQ6TuumewaVih6Cr+tfABJ9bdSm0=' 
WHERE 
  key_id = '3e4c0db734f9f636fb23f819237cec0a230bb94aa75466d95e1bb4e4d42dd2a3' 
  AND (
    token = '0eOaI+CZo3/zxXhSQ6TuumewaVih6Cr+tfABJ9bdSm0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022